For Each Row

This activity runs the activities inside it on each row returned by the Custom Query and Query Data activities or on each result returned by activities that return collections of information, such as Search Repository, Find Entries, Find Manager, Find Group, Retrieve Laserfiche Forms Content, and Verify PDF Signatures.

Note: When using SELECT queries in the Custom Query activity, you must test the query in order to make the columns accessible as tokens to this activity.

How does this activity look in the Designer Pane?

To add this activity to a workflow definition 

• Drag it from the Toolbox Pane and drop it in the Designer Pane.

To configure this activity

Drag and drop activities into this activity.

Select the activity in the Designer Pane to configure the following property boxes in the Properties Pane.

• Activity Name

  Once added to a workflow definition, the default name of an activity can be changed. Providing a custom name for an activity helps you remember the role it plays.

  To name an activity

  1. Add an activity to your workflow by dragging it from the Toolbox Pane and dropping it in the Designer Pane.
  2. Select the activity in the Designer Pane.
  3. Under Activity Name in the Properties Pane, replace the default name.

  

  Note: Activity names cannot be the same as any other activity name in the workflow, they cannot be the same as the workflow's name, they must be less than 100 characters, they must contain at least one alphanumeric character, they cannot be "Name," and they cannot be the same as the activity's runtime type (which is usually only an issue with custom activities).

• Activity Description

  Use the Activity Description to provide descriptive text to help you remember the role that the activity plays in the workflow. All activities contain a default description that you can modify while constructing your workflow.

  To modify an activity description

  1. Add an activity to your workflow by dragging it from the Toolbox Pane and dropping it in the Designer Pane.
  2. Select the activity in the Designer Pane.
  3. Under Activity Description in the Properties Pane, replace the default description.

  

• Get Rows From

  The For Each Row activity can dynamically interact with rows found with activities that return collections of information such as the Custom Query, Query Data, Search Repository, Find Entries, Find Manager, Find Group, Retrieve Laserfiche Forms Content, and Verify PDF Signatures activities.

  To select which collection of information the activity will be performed on

  1. Add the For Each Row activity to your workflow by dragging it from the Toolbox Pane and dropping it in the Designer Pane.
  2. Select the activity in the Designer Pane.
  3. Under Get Rows From in the Properties Pane, click Select.

  

  4. In the Select Collection dialog box, expand the activity that finds the collection of information you want to use with the For Each Row activity.

  

  5. Click the green arrow next to the collection of rows you want this activity to use.

  Note: You can only select collections of information from activities that appear above the activity you are currently configuring in the Designer Pane.

  6. Click OK.